<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>About thresholds</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ul.whs2 { list-style:square; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nAdding features for users\nHighlighting specific sets of data: Thresholds\nAbout thresholds");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>About thresholds</h1>
<p>Thresholds highlight particular data in a report by displaying special 
 cell formats, symbols, images, or replacement text. Thresholds can make 
 analyzing large amounts of data easier because symbols are easy to locate 
 and different font colors are quickly identified. A threshold can also 
 be displayed on a graph report; however, due to the nature of a graph 
 report's normal appearance, a threshold is limited to background formatting 
 only. For more information on using thresholds in graph reports, see the 
 <span style="font-style: italic;"><I>MicroStrategy Basic Reporting Guide</I></span>. 
 Also, for examples with images, see the <span style="font-style: italic;"><I>MicroStrategy 
 Basic Reporting Guide.</I></span></p>
<p>A threshold is made up of two parts: the condition and the formatting 
 that will be applied to the values that meet the conditions. Conditions 
 can vary in complexity depending upon the type of threshold that is created. 
 The data that meets the condition is considered to be data that has passed 
 the threshold of the condition. Once data passes the threshold, cell formatting 
 can be applied, or images or symbols can replace the values in the cells.</p>
<h2>Prerequisites</h2>
<ul type="disc" class="whs1">
	
<li class=p><p>DHTML must be enabled. See 
<a href="DHTML-only_features_in_Web.htm">Enabling 
 DHTML in MicroStrategy Web</a>.</p></li>
	
<li class=p><p>Decide what condition the metric values must meet to 
 have the threshold formatting applied. Common examples of a threshold's 
 condition include sales that exceed a certain amount, revenue that falls 
 below a certain percentage, or employee resource numbers that drop below 
 a particular number. You can use attributes or other metrics on the report 
 to define a threshold's condition. For a specific example of a threshold 
 condition that compares results in two columns on the report, and an image 
 of the resulting report, see the <span style="font-style: italic;"><I>MicroStrategy 
 Basic Reporting Guide</I></span>.</p></li>
	
<li class=p><p>Decide what you want to be displayed on your report 
 when the condition is met. Common examples include displaying important 
 numbers in red, or in white font with a red background, or displaying 
 a red stop sign or a green traffic light in place of certain data.</p></li>
</ul>
<p>&nbsp;You can do the following with thresholds:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>Define an unlimited number of conditions for each metric 
 calculation on the report. Each condition can have a simple or complex 
 expression. You can apply thresholds to any of the metrics that are part 
 of the report definition.</p></li>
	
<li class=p><p>Define the following formatting properties for the cells 
 that meet the threshold condition:</p></li>
	<ul type="square" class="whs2">
		
<li class=p><p>Font type, size, style, and color</p></li>
		
<li class=p><p>Fill (background) color</p></li>
		
<li class=p><p>Alignment</p></li>
		
<li class=p><p>Number format</p></li>
		
<li class=p><p>Borders and patterns</p></li>
	</ul>
	
<li class=p><p>Replace the cell value with any text you want for each 
 cell value that meets the condition specified. For example, you can replace 
 all values where Dollar Sales is greater than $5000 with the text ”Exceeded 
 Sales”.</p></li>
	
<li class=p><p>Replace the cell value with an image when the condition 
 is true. </p></li>
	
<li class=p><p>Replace the cell value with a symbol, selected from 
 a predefined list of symbols. You can also set symbols to be toggled back 
 and forth between the symbol and the underlying value.</p></li>
</ul>
<p>MicroStrategy comes with several default thresholds:</p>
<ul>
<li class=P-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Add_predefined_thresholds.htm">Quick 
 threshold</a>: Quick thresholds apply green, red, or yellow colors or 
 symbols to metric values on your report. The thresholds are automatically 
 formatted, and can be added to a report quickly.</p></li>
	
<li class=P-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_simple_threshold.htm">Visual 
 &nbsp;threshold</a>: Visual thresholds use range expressions 
 (such as Greater Than, Less Than, or Top N%) to determine whether a metric 
 has met the condition. If a metric met the condition, special formatting 
 can be applied to the values, or the values can be replaced with an image 
 or a symbol.</p></li>
	
<li class=P-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_advanced_threshold.htm">Advanced 
 threshold</a>: Advanced thresholds are thresholds that can have conditions 
 based on multiple metrics or attributes. If a value meets the condition, 
 special formatting can be applied to the values, or the values can be 
 replaced with an image or a symbol. </p></li>
</ul>
<h2>Related topics</h2>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a href="Thresholds_on_report.htm">Displaying thresholds 
 on a report</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Thresholds.htm">About 
 thresholds</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Add_predefined_thresholds.htm">Adding 
 a quick threshold to a report</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_simple_threshold.htm">Creating 
 a threshold for a metric based on a metric: Visual thresholds</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_advanced_threshold.htm">Creating 
 a threshold for multiple metrics: Advanced thresholds</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
